{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import sys\n",
    "import warnings\n",
    "warnings.filterwarnings(\"ignore\")\n",
    "plt.rcParams['font.sans-serif'] = ['SimHei']  # 用来正常显示中文标签\n",
    "plt.rcParams['axes.unicode_minus'] = False  # 用来正常显示负号"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_285 = pd.read_excel(\"285号样本原始数据整合.xlsx\", na_values=np.nan, skiprows=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(40, 355)"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_285.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>时间</th>\n",
       "      <th>S-ZORB.CAL_H2.PV</th>\n",
       "      <th>S-ZORB.PDI_2102.PV</th>\n",
       "      <th>S-ZORB.PT_2801.PV</th>\n",
       "      <th>S-ZORB.FC_2801.PV</th>\n",
       "      <th>S-ZORB.TE_2103.PV</th>\n",
       "      <th>S-ZORB.TE_2005.PV</th>\n",
       "      <th>S-ZORB.PT_2101.PV</th>\n",
       "      <th>S-ZORB.PDT_2104.PV</th>\n",
       "      <th>S-ZORB.SIS_PDT_2103B.PV</th>\n",
       "      <th>...</th>\n",
       "      <th>S-ZORB.CAL_1.CANGLIANG.PV</th>\n",
       "      <th>S-ZORB.FT_1006.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_5204.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_1006.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.FT_5204.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.FT_1503.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_1503.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.FT_1504.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_1504.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.PC_1001A.PV</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017-07-17 06:03:00</td>\n",
       "      <td>0.273498</td>\n",
       "      <td>24.17817</td>\n",
       "      <td>2.528462</td>\n",
       "      <td>856.2485</td>\n",
       "      <td>421.5055</td>\n",
       "      <td>421.1933</td>\n",
       "      <td>2.426675</td>\n",
       "      <td>59.71847</td>\n",
       "      <td>1108.377</td>\n",
       "      <td>...</td>\n",
       "      <td>2.358511</td>\n",
       "      <td>3348.074</td>\n",
       "      <td>190.6698</td>\n",
       "      <td>98941230</td>\n",
       "      <td>2433273</td>\n",
       "      <td>2210.004</td>\n",
       "      <td>5147738</td>\n",
       "      <td>2846.390</td>\n",
       "      <td>5982072</td>\n",
       "      <td>-97.22112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017-07-17 06:06:00</td>\n",
       "      <td>0.273493</td>\n",
       "      <td>24.17971</td>\n",
       "      <td>2.528483</td>\n",
       "      <td>856.2297</td>\n",
       "      <td>421.5057</td>\n",
       "      <td>421.1934</td>\n",
       "      <td>2.426696</td>\n",
       "      <td>59.71767</td>\n",
       "      <td>1108.372</td>\n",
       "      <td>...</td>\n",
       "      <td>2.358513</td>\n",
       "      <td>3346.716</td>\n",
       "      <td>190.6711</td>\n",
       "      <td>98941420</td>\n",
       "      <td>2433282</td>\n",
       "      <td>2209.531</td>\n",
       "      <td>5147816</td>\n",
       "      <td>2846.416</td>\n",
       "      <td>5982209</td>\n",
       "      <td>-97.22059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017-07-17 06:09:00</td>\n",
       "      <td>0.273488</td>\n",
       "      <td>24.18125</td>\n",
       "      <td>2.528504</td>\n",
       "      <td>856.2109</td>\n",
       "      <td>421.5059</td>\n",
       "      <td>421.1936</td>\n",
       "      <td>2.426718</td>\n",
       "      <td>59.71688</td>\n",
       "      <td>1108.368</td>\n",
       "      <td>...</td>\n",
       "      <td>2.358516</td>\n",
       "      <td>3345.357</td>\n",
       "      <td>190.6723</td>\n",
       "      <td>98941610</td>\n",
       "      <td>2433291</td>\n",
       "      <td>2209.059</td>\n",
       "      <td>5147894</td>\n",
       "      <td>2846.442</td>\n",
       "      <td>5982347</td>\n",
       "      <td>-97.22005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017-07-17 06:12:00</td>\n",
       "      <td>0.273483</td>\n",
       "      <td>24.18279</td>\n",
       "      <td>2.528525</td>\n",
       "      <td>856.1922</td>\n",
       "      <td>421.5061</td>\n",
       "      <td>421.1937</td>\n",
       "      <td>2.426739</td>\n",
       "      <td>59.71609</td>\n",
       "      <td>1108.363</td>\n",
       "      <td>...</td>\n",
       "      <td>2.358518</td>\n",
       "      <td>3343.999</td>\n",
       "      <td>190.6736</td>\n",
       "      <td>98941800</td>\n",
       "      <td>2433300</td>\n",
       "      <td>2208.586</td>\n",
       "      <td>5147972</td>\n",
       "      <td>2846.468</td>\n",
       "      <td>5982484</td>\n",
       "      <td>-97.21952</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017-07-17 06:15:00</td>\n",
       "      <td>0.273478</td>\n",
       "      <td>24.18434</td>\n",
       "      <td>2.528546</td>\n",
       "      <td>856.1734</td>\n",
       "      <td>421.5063</td>\n",
       "      <td>421.1939</td>\n",
       "      <td>2.426760</td>\n",
       "      <td>59.71530</td>\n",
       "      <td>1108.358</td>\n",
       "      <td>...</td>\n",
       "      <td>2.358521</td>\n",
       "      <td>3342.640</td>\n",
       "      <td>190.6748</td>\n",
       "      <td>98941980</td>\n",
       "      <td>2433309</td>\n",
       "      <td>2208.114</td>\n",
       "      <td>5148050</td>\n",
       "      <td>2846.494</td>\n",
       "      <td>5982621</td>\n",
       "      <td>-97.21899</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 355 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     时间  S-ZORB.CAL_H2.PV  S-ZORB.PDI_2102.PV  \\\n",
       "0   2017-07-17 06:03:00          0.273498            24.17817   \n",
       "1   2017-07-17 06:06:00          0.273493            24.17971   \n",
       "2   2017-07-17 06:09:00          0.273488            24.18125   \n",
       "3   2017-07-17 06:12:00          0.273483            24.18279   \n",
       "4   2017-07-17 06:15:00          0.273478            24.18434   \n",
       "\n",
       "   S-ZORB.PT_2801.PV  S-ZORB.FC_2801.PV  S-ZORB.TE_2103.PV  S-ZORB.TE_2005.PV  \\\n",
       "0           2.528462           856.2485           421.5055           421.1933   \n",
       "1           2.528483           856.2297           421.5057           421.1934   \n",
       "2           2.528504           856.2109           421.5059           421.1936   \n",
       "3           2.528525           856.1922           421.5061           421.1937   \n",
       "4           2.528546           856.1734           421.5063           421.1939   \n",
       "\n",
       "   S-ZORB.PT_2101.PV  S-ZORB.PDT_2104.PV  S-ZORB.SIS_PDT_2103B.PV  ...  \\\n",
       "0           2.426675            59.71847                 1108.377  ...   \n",
       "1           2.426696            59.71767                 1108.372  ...   \n",
       "2           2.426718            59.71688                 1108.368  ...   \n",
       "3           2.426739            59.71609                 1108.363  ...   \n",
       "4           2.426760            59.71530                 1108.358  ...   \n",
       "\n",
       "   S-ZORB.CAL_1.CANGLIANG.PV  S-ZORB.FT_1006.DACA.PV  S-ZORB.FT_5204.DACA.PV  \\\n",
       "0                   2.358511                3348.074                190.6698   \n",
       "1                   2.358513                3346.716                190.6711   \n",
       "2                   2.358516                3345.357                190.6723   \n",
       "3                   2.358518                3343.999                190.6736   \n",
       "4                   2.358521                3342.640                190.6748   \n",
       "\n",
       "   S-ZORB.FT_1006.TOTALIZERA.PV  S-ZORB.FT_5204.TOTALIZERA.PV  \\\n",
       "0                      98941230                       2433273   \n",
       "1                      98941420                       2433282   \n",
       "2                      98941610                       2433291   \n",
       "3                      98941800                       2433300   \n",
       "4                      98941980                       2433309   \n",
       "\n",
       "   S-ZORB.FT_1503.DACA.PV  S-ZORB.FT_1503.TOTALIZERA.PV  \\\n",
       "0                2210.004                       5147738   \n",
       "1                2209.531                       5147816   \n",
       "2                2209.059                       5147894   \n",
       "3                2208.586                       5147972   \n",
       "4                2208.114                       5148050   \n",
       "\n",
       "   S-ZORB.FT_1504.DACA.PV  S-ZORB.FT_1504.TOTALIZERA.PV  S-ZORB.PC_1001A.PV  \n",
       "0                2846.390                       5982072           -97.22112  \n",
       "1                2846.416                       5982209           -97.22059  \n",
       "2                2846.442                       5982347           -97.22005  \n",
       "3                2846.468                       5982484           -97.21952  \n",
       "4                2846.494                       5982621           -97.21899  \n",
       "\n",
       "[5 rows x 355 columns]"
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_285.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [],
   "source": [
    "# ser1表示传入DataFrame的某一列\n",
    "error_value_list = []\n",
    "def three_sigma(ser1):\n",
    "    # 求平均值\n",
    "    mean_value = ser1.mean()\n",
    "    # 求标准差\n",
    "    std_value = ser1.std()\n",
    "    # 位于(μ-3σ,μ+3σ)区间内的数据是正常的，不在该区间的数据是异常的\n",
    "    # ser1中的数值小于μ-3σ或大于μ+3σ均为异常值\n",
    "    # 一旦发现异常值就标注为True，否则标注为False\n",
    "    rule = (mean_value - 3 * std_value > ser1) | (mean_value + 3 * std_value < ser1)\n",
    "    #print(rule)\n",
    "    if rule is True:\n",
    "        # 返回异常值的位置索引\n",
    "        index = np.arange(ser1.shape[0])[rule]\n",
    "        error_value_list.append(index)\n",
    "    return error_value_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "285号样本原始数据中不含异常值！\n"
     ]
    }
   ],
   "source": [
    "error_value_count = 0\n",
    "\n",
    "for i in range(1, len(data_285.columns)):\n",
    "    error_value_list = three_sigma(data_285[data_285.columns[i]])\n",
    "    for j in range(len(error_value_list)):\n",
    "        print(data_285[data_285.columns[i]].iloc[error_value_list[j]])\n",
    "        error_value_count += 1\n",
    "if error_value_count == 0:\n",
    "    print(\"285号样本原始数据中不含异常值！\")\n",
    "else:\n",
    "    print(\"285号样本原始数据中共含有\" + str(error_value_count) + \"个异常值！\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_313 = pd.read_excel(\"313号样本原始数据整合.xlsx\", na_values=np.nan, skiprows=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(40, 355)"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_313.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>时间</th>\n",
       "      <th>S-ZORB.CAL_H2.PV</th>\n",
       "      <th>S-ZORB.PDI_2102.PV</th>\n",
       "      <th>S-ZORB.PT_2801.PV</th>\n",
       "      <th>S-ZORB.FC_2801.PV</th>\n",
       "      <th>S-ZORB.TE_2103.PV</th>\n",
       "      <th>S-ZORB.TE_2005.PV</th>\n",
       "      <th>S-ZORB.PT_2101.PV</th>\n",
       "      <th>S-ZORB.PDT_2104.PV</th>\n",
       "      <th>S-ZORB.SIS_PDT_2103B.PV</th>\n",
       "      <th>...</th>\n",
       "      <th>S-ZORB.CAL_1.CANGLIANG.PV</th>\n",
       "      <th>S-ZORB.FT_1006.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_5204.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_1006.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.FT_5204.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.FT_1503.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_1503.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.FT_1504.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_1504.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.PC_1001A.PV</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017-05-15 06:03:00</td>\n",
       "      <td>0.261208</td>\n",
       "      <td>17.06828</td>\n",
       "      <td>2.414703</td>\n",
       "      <td>838.6098</td>\n",
       "      <td>420.2411</td>\n",
       "      <td>419.6024</td>\n",
       "      <td>2.313425</td>\n",
       "      <td>61.68757</td>\n",
       "      <td>1250.785</td>\n",
       "      <td>...</td>\n",
       "      <td>2.999368</td>\n",
       "      <td>10119.40</td>\n",
       "      <td>150.1902</td>\n",
       "      <td>87929500</td>\n",
       "      <td>2205722</td>\n",
       "      <td>1947.383</td>\n",
       "      <td>2147672</td>\n",
       "      <td>2472.575</td>\n",
       "      <td>2151723</td>\n",
       "      <td>-113.3863</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017-05-15 06:06:00</td>\n",
       "      <td>0.260958</td>\n",
       "      <td>16.86597</td>\n",
       "      <td>2.412846</td>\n",
       "      <td>838.8535</td>\n",
       "      <td>420.7948</td>\n",
       "      <td>420.3819</td>\n",
       "      <td>2.311459</td>\n",
       "      <td>61.75313</td>\n",
       "      <td>1250.780</td>\n",
       "      <td>...</td>\n",
       "      <td>3.053287</td>\n",
       "      <td>10097.87</td>\n",
       "      <td>149.8263</td>\n",
       "      <td>87930000</td>\n",
       "      <td>2205729</td>\n",
       "      <td>2215.770</td>\n",
       "      <td>2147780</td>\n",
       "      <td>2462.883</td>\n",
       "      <td>2151846</td>\n",
       "      <td>-113.3858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017-05-15 06:09:00</td>\n",
       "      <td>0.260708</td>\n",
       "      <td>16.66366</td>\n",
       "      <td>2.410989</td>\n",
       "      <td>839.0970</td>\n",
       "      <td>421.3485</td>\n",
       "      <td>421.1614</td>\n",
       "      <td>2.309492</td>\n",
       "      <td>61.81869</td>\n",
       "      <td>1250.775</td>\n",
       "      <td>...</td>\n",
       "      <td>3.107207</td>\n",
       "      <td>10076.34</td>\n",
       "      <td>149.4624</td>\n",
       "      <td>87930500</td>\n",
       "      <td>2205737</td>\n",
       "      <td>2484.157</td>\n",
       "      <td>2147888</td>\n",
       "      <td>2453.191</td>\n",
       "      <td>2151969</td>\n",
       "      <td>-113.3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017-05-15 06:12:00</td>\n",
       "      <td>0.262787</td>\n",
       "      <td>17.59503</td>\n",
       "      <td>2.419262</td>\n",
       "      <td>841.1829</td>\n",
       "      <td>422.3332</td>\n",
       "      <td>421.9007</td>\n",
       "      <td>2.317966</td>\n",
       "      <td>61.66451</td>\n",
       "      <td>1250.771</td>\n",
       "      <td>...</td>\n",
       "      <td>2.948391</td>\n",
       "      <td>10093.86</td>\n",
       "      <td>149.6110</td>\n",
       "      <td>87931010</td>\n",
       "      <td>2205744</td>\n",
       "      <td>2099.506</td>\n",
       "      <td>2148029</td>\n",
       "      <td>2456.075</td>\n",
       "      <td>2152091</td>\n",
       "      <td>-113.3847</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017-05-15 06:15:00</td>\n",
       "      <td>0.266825</td>\n",
       "      <td>18.00510</td>\n",
       "      <td>2.417170</td>\n",
       "      <td>866.1335</td>\n",
       "      <td>422.3154</td>\n",
       "      <td>422.3370</td>\n",
       "      <td>2.315674</td>\n",
       "      <td>61.18709</td>\n",
       "      <td>1250.766</td>\n",
       "      <td>...</td>\n",
       "      <td>2.933445</td>\n",
       "      <td>10115.17</td>\n",
       "      <td>151.6057</td>\n",
       "      <td>87931510</td>\n",
       "      <td>2205751</td>\n",
       "      <td>1904.816</td>\n",
       "      <td>2148111</td>\n",
       "      <td>2467.434</td>\n",
       "      <td>2152214</td>\n",
       "      <td>-113.3842</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 355 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     时间  S-ZORB.CAL_H2.PV  S-ZORB.PDI_2102.PV  \\\n",
       "0   2017-05-15 06:03:00          0.261208            17.06828   \n",
       "1   2017-05-15 06:06:00          0.260958            16.86597   \n",
       "2   2017-05-15 06:09:00          0.260708            16.66366   \n",
       "3   2017-05-15 06:12:00          0.262787            17.59503   \n",
       "4   2017-05-15 06:15:00          0.266825            18.00510   \n",
       "\n",
       "   S-ZORB.PT_2801.PV  S-ZORB.FC_2801.PV  S-ZORB.TE_2103.PV  S-ZORB.TE_2005.PV  \\\n",
       "0           2.414703           838.6098           420.2411           419.6024   \n",
       "1           2.412846           838.8535           420.7948           420.3819   \n",
       "2           2.410989           839.0970           421.3485           421.1614   \n",
       "3           2.419262           841.1829           422.3332           421.9007   \n",
       "4           2.417170           866.1335           422.3154           422.3370   \n",
       "\n",
       "   S-ZORB.PT_2101.PV  S-ZORB.PDT_2104.PV  S-ZORB.SIS_PDT_2103B.PV  ...  \\\n",
       "0           2.313425            61.68757                 1250.785  ...   \n",
       "1           2.311459            61.75313                 1250.780  ...   \n",
       "2           2.309492            61.81869                 1250.775  ...   \n",
       "3           2.317966            61.66451                 1250.771  ...   \n",
       "4           2.315674            61.18709                 1250.766  ...   \n",
       "\n",
       "   S-ZORB.CAL_1.CANGLIANG.PV  S-ZORB.FT_1006.DACA.PV  S-ZORB.FT_5204.DACA.PV  \\\n",
       "0                   2.999368                10119.40                150.1902   \n",
       "1                   3.053287                10097.87                149.8263   \n",
       "2                   3.107207                10076.34                149.4624   \n",
       "3                   2.948391                10093.86                149.6110   \n",
       "4                   2.933445                10115.17                151.6057   \n",
       "\n",
       "   S-ZORB.FT_1006.TOTALIZERA.PV  S-ZORB.FT_5204.TOTALIZERA.PV  \\\n",
       "0                      87929500                       2205722   \n",
       "1                      87930000                       2205729   \n",
       "2                      87930500                       2205737   \n",
       "3                      87931010                       2205744   \n",
       "4                      87931510                       2205751   \n",
       "\n",
       "   S-ZORB.FT_1503.DACA.PV  S-ZORB.FT_1503.TOTALIZERA.PV  \\\n",
       "0                1947.383                       2147672   \n",
       "1                2215.770                       2147780   \n",
       "2                2484.157                       2147888   \n",
       "3                2099.506                       2148029   \n",
       "4                1904.816                       2148111   \n",
       "\n",
       "   S-ZORB.FT_1504.DACA.PV  S-ZORB.FT_1504.TOTALIZERA.PV  S-ZORB.PC_1001A.PV  \n",
       "0                2472.575                       2151723           -113.3863  \n",
       "1                2462.883                       2151846           -113.3858  \n",
       "2                2453.191                       2151969           -113.3853  \n",
       "3                2456.075                       2152091           -113.3847  \n",
       "4                2467.434                       2152214           -113.3842  \n",
       "\n",
       "[5 rows x 355 columns]"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_313.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "313号样本原始数据中不含异常值！\n"
     ]
    }
   ],
   "source": [
    "error_value_count = 0\n",
    "\n",
    "for i in range(1, len(data_313.columns)):\n",
    "    error_value_list = three_sigma(data_313[data_285.columns[i]])\n",
    "    for j in range(len(error_value_list)):\n",
    "        print(data_313[data_313.columns[i]].iloc[error_value_list[j]])\n",
    "        error_value_count += 1\n",
    "if error_value_count == 0:\n",
    "    print(\"313号样本原始数据中不含异常值！\")\n",
    "else:\n",
    "    print(\"313号样本原始数据中共含有\" + str(error_value_count) + \"个异常值！\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_285 = data_285.drop(['时间'], axis=1)\n",
    "data_313 = data_313.drop(['时间'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>S-ZORB.CAL_H2.PV</th>\n",
       "      <th>S-ZORB.PDI_2102.PV</th>\n",
       "      <th>S-ZORB.PT_2801.PV</th>\n",
       "      <th>S-ZORB.FC_2801.PV</th>\n",
       "      <th>S-ZORB.TE_2103.PV</th>\n",
       "      <th>S-ZORB.TE_2005.PV</th>\n",
       "      <th>S-ZORB.PT_2101.PV</th>\n",
       "      <th>S-ZORB.PDT_2104.PV</th>\n",
       "      <th>S-ZORB.SIS_PDT_2103B.PV</th>\n",
       "      <th>S-ZORB.TC_2101.PV</th>\n",
       "      <th>...</th>\n",
       "      <th>S-ZORB.CAL_1.CANGLIANG.PV</th>\n",
       "      <th>S-ZORB.FT_1006.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_5204.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_1006.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.FT_5204.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.FT_1503.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_1503.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.FT_1504.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_1504.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.PC_1001A.PV</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.273498</td>\n",
       "      <td>24.17817</td>\n",
       "      <td>2.528462</td>\n",
       "      <td>856.2485</td>\n",
       "      <td>421.5055</td>\n",
       "      <td>421.1933</td>\n",
       "      <td>2.426675</td>\n",
       "      <td>59.71847</td>\n",
       "      <td>1108.377</td>\n",
       "      <td>244.1175</td>\n",
       "      <td>...</td>\n",
       "      <td>2.358511</td>\n",
       "      <td>3348.074</td>\n",
       "      <td>190.6698</td>\n",
       "      <td>98941230</td>\n",
       "      <td>2433273</td>\n",
       "      <td>2210.004</td>\n",
       "      <td>5147738</td>\n",
       "      <td>2846.390</td>\n",
       "      <td>5982072</td>\n",
       "      <td>-97.22112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.273493</td>\n",
       "      <td>24.17971</td>\n",
       "      <td>2.528483</td>\n",
       "      <td>856.2297</td>\n",
       "      <td>421.5057</td>\n",
       "      <td>421.1934</td>\n",
       "      <td>2.426696</td>\n",
       "      <td>59.71767</td>\n",
       "      <td>1108.372</td>\n",
       "      <td>244.1178</td>\n",
       "      <td>...</td>\n",
       "      <td>2.358513</td>\n",
       "      <td>3346.716</td>\n",
       "      <td>190.6711</td>\n",
       "      <td>98941420</td>\n",
       "      <td>2433282</td>\n",
       "      <td>2209.531</td>\n",
       "      <td>5147816</td>\n",
       "      <td>2846.416</td>\n",
       "      <td>5982209</td>\n",
       "      <td>-97.22059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.273488</td>\n",
       "      <td>24.18125</td>\n",
       "      <td>2.528504</td>\n",
       "      <td>856.2109</td>\n",
       "      <td>421.5059</td>\n",
       "      <td>421.1936</td>\n",
       "      <td>2.426718</td>\n",
       "      <td>59.71688</td>\n",
       "      <td>1108.368</td>\n",
       "      <td>244.1180</td>\n",
       "      <td>...</td>\n",
       "      <td>2.358516</td>\n",
       "      <td>3345.357</td>\n",
       "      <td>190.6723</td>\n",
       "      <td>98941610</td>\n",
       "      <td>2433291</td>\n",
       "      <td>2209.059</td>\n",
       "      <td>5147894</td>\n",
       "      <td>2846.442</td>\n",
       "      <td>5982347</td>\n",
       "      <td>-97.22005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.273483</td>\n",
       "      <td>24.18279</td>\n",
       "      <td>2.528525</td>\n",
       "      <td>856.1922</td>\n",
       "      <td>421.5061</td>\n",
       "      <td>421.1937</td>\n",
       "      <td>2.426739</td>\n",
       "      <td>59.71609</td>\n",
       "      <td>1108.363</td>\n",
       "      <td>244.1182</td>\n",
       "      <td>...</td>\n",
       "      <td>2.358518</td>\n",
       "      <td>3343.999</td>\n",
       "      <td>190.6736</td>\n",
       "      <td>98941800</td>\n",
       "      <td>2433300</td>\n",
       "      <td>2208.586</td>\n",
       "      <td>5147972</td>\n",
       "      <td>2846.468</td>\n",
       "      <td>5982484</td>\n",
       "      <td>-97.21952</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.273478</td>\n",
       "      <td>24.18434</td>\n",
       "      <td>2.528546</td>\n",
       "      <td>856.1734</td>\n",
       "      <td>421.5063</td>\n",
       "      <td>421.1939</td>\n",
       "      <td>2.426760</td>\n",
       "      <td>59.71530</td>\n",
       "      <td>1108.358</td>\n",
       "      <td>244.1184</td>\n",
       "      <td>...</td>\n",
       "      <td>2.358521</td>\n",
       "      <td>3342.640</td>\n",
       "      <td>190.6748</td>\n",
       "      <td>98941980</td>\n",
       "      <td>2433309</td>\n",
       "      <td>2208.114</td>\n",
       "      <td>5148050</td>\n",
       "      <td>2846.494</td>\n",
       "      <td>5982621</td>\n",
       "      <td>-97.21899</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 354 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   S-ZORB.CAL_H2.PV  S-ZORB.PDI_2102.PV  S-ZORB.PT_2801.PV  S-ZORB.FC_2801.PV  \\\n",
       "0          0.273498            24.17817           2.528462           856.2485   \n",
       "1          0.273493            24.17971           2.528483           856.2297   \n",
       "2          0.273488            24.18125           2.528504           856.2109   \n",
       "3          0.273483            24.18279           2.528525           856.1922   \n",
       "4          0.273478            24.18434           2.528546           856.1734   \n",
       "\n",
       "   S-ZORB.TE_2103.PV  S-ZORB.TE_2005.PV  S-ZORB.PT_2101.PV  \\\n",
       "0           421.5055           421.1933           2.426675   \n",
       "1           421.5057           421.1934           2.426696   \n",
       "2           421.5059           421.1936           2.426718   \n",
       "3           421.5061           421.1937           2.426739   \n",
       "4           421.5063           421.1939           2.426760   \n",
       "\n",
       "   S-ZORB.PDT_2104.PV  S-ZORB.SIS_PDT_2103B.PV  S-ZORB.TC_2101.PV  ...  \\\n",
       "0            59.71847                 1108.377           244.1175  ...   \n",
       "1            59.71767                 1108.372           244.1178  ...   \n",
       "2            59.71688                 1108.368           244.1180  ...   \n",
       "3            59.71609                 1108.363           244.1182  ...   \n",
       "4            59.71530                 1108.358           244.1184  ...   \n",
       "\n",
       "   S-ZORB.CAL_1.CANGLIANG.PV  S-ZORB.FT_1006.DACA.PV  S-ZORB.FT_5204.DACA.PV  \\\n",
       "0                   2.358511                3348.074                190.6698   \n",
       "1                   2.358513                3346.716                190.6711   \n",
       "2                   2.358516                3345.357                190.6723   \n",
       "3                   2.358518                3343.999                190.6736   \n",
       "4                   2.358521                3342.640                190.6748   \n",
       "\n",
       "   S-ZORB.FT_1006.TOTALIZERA.PV  S-ZORB.FT_5204.TOTALIZERA.PV  \\\n",
       "0                      98941230                       2433273   \n",
       "1                      98941420                       2433282   \n",
       "2                      98941610                       2433291   \n",
       "3                      98941800                       2433300   \n",
       "4                      98941980                       2433309   \n",
       "\n",
       "   S-ZORB.FT_1503.DACA.PV  S-ZORB.FT_1503.TOTALIZERA.PV  \\\n",
       "0                2210.004                       5147738   \n",
       "1                2209.531                       5147816   \n",
       "2                2209.059                       5147894   \n",
       "3                2208.586                       5147972   \n",
       "4                2208.114                       5148050   \n",
       "\n",
       "   S-ZORB.FT_1504.DACA.PV  S-ZORB.FT_1504.TOTALIZERA.PV  S-ZORB.PC_1001A.PV  \n",
       "0                2846.390                       5982072           -97.22112  \n",
       "1                2846.416                       5982209           -97.22059  \n",
       "2                2846.442                       5982347           -97.22005  \n",
       "3                2846.468                       5982484           -97.21952  \n",
       "4                2846.494                       5982621           -97.21899  \n",
       "\n",
       "[5 rows x 354 columns]"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_285.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>S-ZORB.CAL_H2.PV</th>\n",
       "      <th>S-ZORB.PDI_2102.PV</th>\n",
       "      <th>S-ZORB.PT_2801.PV</th>\n",
       "      <th>S-ZORB.FC_2801.PV</th>\n",
       "      <th>S-ZORB.TE_2103.PV</th>\n",
       "      <th>S-ZORB.TE_2005.PV</th>\n",
       "      <th>S-ZORB.PT_2101.PV</th>\n",
       "      <th>S-ZORB.PDT_2104.PV</th>\n",
       "      <th>S-ZORB.SIS_PDT_2103B.PV</th>\n",
       "      <th>S-ZORB.TC_2101.PV</th>\n",
       "      <th>...</th>\n",
       "      <th>S-ZORB.CAL_1.CANGLIANG.PV</th>\n",
       "      <th>S-ZORB.FT_1006.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_5204.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_1006.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.FT_5204.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.FT_1503.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_1503.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.FT_1504.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_1504.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.PC_1001A.PV</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.261208</td>\n",
       "      <td>17.06828</td>\n",
       "      <td>2.414703</td>\n",
       "      <td>838.6098</td>\n",
       "      <td>420.2411</td>\n",
       "      <td>419.6024</td>\n",
       "      <td>2.313425</td>\n",
       "      <td>61.68757</td>\n",
       "      <td>1250.785</td>\n",
       "      <td>245.1287</td>\n",
       "      <td>...</td>\n",
       "      <td>2.999368</td>\n",
       "      <td>10119.40</td>\n",
       "      <td>150.1902</td>\n",
       "      <td>87929500</td>\n",
       "      <td>2205722</td>\n",
       "      <td>1947.383</td>\n",
       "      <td>2147672</td>\n",
       "      <td>2472.575</td>\n",
       "      <td>2151723</td>\n",
       "      <td>-113.3863</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.260958</td>\n",
       "      <td>16.86597</td>\n",
       "      <td>2.412846</td>\n",
       "      <td>838.8535</td>\n",
       "      <td>420.7948</td>\n",
       "      <td>420.3819</td>\n",
       "      <td>2.311459</td>\n",
       "      <td>61.75313</td>\n",
       "      <td>1250.780</td>\n",
       "      <td>245.6239</td>\n",
       "      <td>...</td>\n",
       "      <td>3.053287</td>\n",
       "      <td>10097.87</td>\n",
       "      <td>149.8263</td>\n",
       "      <td>87930000</td>\n",
       "      <td>2205729</td>\n",
       "      <td>2215.770</td>\n",
       "      <td>2147780</td>\n",
       "      <td>2462.883</td>\n",
       "      <td>2151846</td>\n",
       "      <td>-113.3858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.260708</td>\n",
       "      <td>16.66366</td>\n",
       "      <td>2.410989</td>\n",
       "      <td>839.0970</td>\n",
       "      <td>421.3485</td>\n",
       "      <td>421.1614</td>\n",
       "      <td>2.309492</td>\n",
       "      <td>61.81869</td>\n",
       "      <td>1250.775</td>\n",
       "      <td>246.1192</td>\n",
       "      <td>...</td>\n",
       "      <td>3.107207</td>\n",
       "      <td>10076.34</td>\n",
       "      <td>149.4624</td>\n",
       "      <td>87930500</td>\n",
       "      <td>2205737</td>\n",
       "      <td>2484.157</td>\n",
       "      <td>2147888</td>\n",
       "      <td>2453.191</td>\n",
       "      <td>2151969</td>\n",
       "      <td>-113.3853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.262787</td>\n",
       "      <td>17.59503</td>\n",
       "      <td>2.419262</td>\n",
       "      <td>841.1829</td>\n",
       "      <td>422.3332</td>\n",
       "      <td>421.9007</td>\n",
       "      <td>2.317966</td>\n",
       "      <td>61.66451</td>\n",
       "      <td>1250.771</td>\n",
       "      <td>246.5508</td>\n",
       "      <td>...</td>\n",
       "      <td>2.948391</td>\n",
       "      <td>10093.86</td>\n",
       "      <td>149.6110</td>\n",
       "      <td>87931010</td>\n",
       "      <td>2205744</td>\n",
       "      <td>2099.506</td>\n",
       "      <td>2148029</td>\n",
       "      <td>2456.075</td>\n",
       "      <td>2152091</td>\n",
       "      <td>-113.3847</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.266825</td>\n",
       "      <td>18.00510</td>\n",
       "      <td>2.417170</td>\n",
       "      <td>866.1335</td>\n",
       "      <td>422.3154</td>\n",
       "      <td>422.3370</td>\n",
       "      <td>2.315674</td>\n",
       "      <td>61.18709</td>\n",
       "      <td>1250.766</td>\n",
       "      <td>246.9335</td>\n",
       "      <td>...</td>\n",
       "      <td>2.933445</td>\n",
       "      <td>10115.17</td>\n",
       "      <td>151.6057</td>\n",
       "      <td>87931510</td>\n",
       "      <td>2205751</td>\n",
       "      <td>1904.816</td>\n",
       "      <td>2148111</td>\n",
       "      <td>2467.434</td>\n",
       "      <td>2152214</td>\n",
       "      <td>-113.3842</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 354 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   S-ZORB.CAL_H2.PV  S-ZORB.PDI_2102.PV  S-ZORB.PT_2801.PV  S-ZORB.FC_2801.PV  \\\n",
       "0          0.261208            17.06828           2.414703           838.6098   \n",
       "1          0.260958            16.86597           2.412846           838.8535   \n",
       "2          0.260708            16.66366           2.410989           839.0970   \n",
       "3          0.262787            17.59503           2.419262           841.1829   \n",
       "4          0.266825            18.00510           2.417170           866.1335   \n",
       "\n",
       "   S-ZORB.TE_2103.PV  S-ZORB.TE_2005.PV  S-ZORB.PT_2101.PV  \\\n",
       "0           420.2411           419.6024           2.313425   \n",
       "1           420.7948           420.3819           2.311459   \n",
       "2           421.3485           421.1614           2.309492   \n",
       "3           422.3332           421.9007           2.317966   \n",
       "4           422.3154           422.3370           2.315674   \n",
       "\n",
       "   S-ZORB.PDT_2104.PV  S-ZORB.SIS_PDT_2103B.PV  S-ZORB.TC_2101.PV  ...  \\\n",
       "0            61.68757                 1250.785           245.1287  ...   \n",
       "1            61.75313                 1250.780           245.6239  ...   \n",
       "2            61.81869                 1250.775           246.1192  ...   \n",
       "3            61.66451                 1250.771           246.5508  ...   \n",
       "4            61.18709                 1250.766           246.9335  ...   \n",
       "\n",
       "   S-ZORB.CAL_1.CANGLIANG.PV  S-ZORB.FT_1006.DACA.PV  S-ZORB.FT_5204.DACA.PV  \\\n",
       "0                   2.999368                10119.40                150.1902   \n",
       "1                   3.053287                10097.87                149.8263   \n",
       "2                   3.107207                10076.34                149.4624   \n",
       "3                   2.948391                10093.86                149.6110   \n",
       "4                   2.933445                10115.17                151.6057   \n",
       "\n",
       "   S-ZORB.FT_1006.TOTALIZERA.PV  S-ZORB.FT_5204.TOTALIZERA.PV  \\\n",
       "0                      87929500                       2205722   \n",
       "1                      87930000                       2205729   \n",
       "2                      87930500                       2205737   \n",
       "3                      87931010                       2205744   \n",
       "4                      87931510                       2205751   \n",
       "\n",
       "   S-ZORB.FT_1503.DACA.PV  S-ZORB.FT_1503.TOTALIZERA.PV  \\\n",
       "0                1947.383                       2147672   \n",
       "1                2215.770                       2147780   \n",
       "2                2484.157                       2147888   \n",
       "3                2099.506                       2148029   \n",
       "4                1904.816                       2148111   \n",
       "\n",
       "   S-ZORB.FT_1504.DACA.PV  S-ZORB.FT_1504.TOTALIZERA.PV  S-ZORB.PC_1001A.PV  \n",
       "0                2472.575                       2151723           -113.3863  \n",
       "1                2462.883                       2151846           -113.3858  \n",
       "2                2453.191                       2151969           -113.3853  \n",
       "3                2456.075                       2152091           -113.3847  \n",
       "4                2467.434                       2152214           -113.3842  \n",
       "\n",
       "[5 rows x 354 columns]"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_313.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_285 = data_285.append(data_285.mean(), ignore_index=True)\n",
    "data_313 = data_313.append(data_313.mean(), ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>S-ZORB.CAL_H2.PV</th>\n",
       "      <th>S-ZORB.PDI_2102.PV</th>\n",
       "      <th>S-ZORB.PT_2801.PV</th>\n",
       "      <th>S-ZORB.FC_2801.PV</th>\n",
       "      <th>S-ZORB.TE_2103.PV</th>\n",
       "      <th>S-ZORB.TE_2005.PV</th>\n",
       "      <th>S-ZORB.PT_2101.PV</th>\n",
       "      <th>S-ZORB.PDT_2104.PV</th>\n",
       "      <th>S-ZORB.SIS_PDT_2103B.PV</th>\n",
       "      <th>S-ZORB.TC_2101.PV</th>\n",
       "      <th>...</th>\n",
       "      <th>S-ZORB.CAL_1.CANGLIANG.PV</th>\n",
       "      <th>S-ZORB.FT_1006.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_5204.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_1006.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.FT_5204.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.FT_1503.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_1503.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.FT_1504.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_1504.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.PC_1001A.PV</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>0.273399</td>\n",
       "      <td>24.208241</td>\n",
       "      <td>2.52887</td>\n",
       "      <td>855.882523</td>\n",
       "      <td>421.509325</td>\n",
       "      <td>421.196235</td>\n",
       "      <td>2.427093</td>\n",
       "      <td>59.703011</td>\n",
       "      <td>1108.285375</td>\n",
       "      <td>244.121748</td>\n",
       "      <td>...</td>\n",
       "      <td>2.358559</td>\n",
       "      <td>3321.5832</td>\n",
       "      <td>190.6942</td>\n",
       "      <td>98944916.75</td>\n",
       "      <td>2433448.0</td>\n",
       "      <td>2200.7891</td>\n",
       "      <td>5149259.0</td>\n",
       "      <td>2846.8966</td>\n",
       "      <td>5984749.325</td>\n",
       "      <td>-97.210697</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 354 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    S-ZORB.CAL_H2.PV  S-ZORB.PDI_2102.PV  S-ZORB.PT_2801.PV  \\\n",
       "40          0.273399           24.208241            2.52887   \n",
       "\n",
       "    S-ZORB.FC_2801.PV  S-ZORB.TE_2103.PV  S-ZORB.TE_2005.PV  \\\n",
       "40         855.882523         421.509325         421.196235   \n",
       "\n",
       "    S-ZORB.PT_2101.PV  S-ZORB.PDT_2104.PV  S-ZORB.SIS_PDT_2103B.PV  \\\n",
       "40           2.427093           59.703011              1108.285375   \n",
       "\n",
       "    S-ZORB.TC_2101.PV  ...  S-ZORB.CAL_1.CANGLIANG.PV  S-ZORB.FT_1006.DACA.PV  \\\n",
       "40         244.121748  ...                   2.358559               3321.5832   \n",
       "\n",
       "    S-ZORB.FT_5204.DACA.PV  S-ZORB.FT_1006.TOTALIZERA.PV  \\\n",
       "40                190.6942                   98944916.75   \n",
       "\n",
       "    S-ZORB.FT_5204.TOTALIZERA.PV  S-ZORB.FT_1503.DACA.PV  \\\n",
       "40                     2433448.0               2200.7891   \n",
       "\n",
       "    S-ZORB.FT_1503.TOTALIZERA.PV  S-ZORB.FT_1504.DACA.PV  \\\n",
       "40                     5149259.0               2846.8966   \n",
       "\n",
       "    S-ZORB.FT_1504.TOTALIZERA.PV  S-ZORB.PC_1001A.PV  \n",
       "40                   5984749.325          -97.210697  \n",
       "\n",
       "[1 rows x 354 columns]"
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_285.tail(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>S-ZORB.CAL_H2.PV</th>\n",
       "      <th>S-ZORB.PDI_2102.PV</th>\n",
       "      <th>S-ZORB.PT_2801.PV</th>\n",
       "      <th>S-ZORB.FC_2801.PV</th>\n",
       "      <th>S-ZORB.TE_2103.PV</th>\n",
       "      <th>S-ZORB.TE_2005.PV</th>\n",
       "      <th>S-ZORB.PT_2101.PV</th>\n",
       "      <th>S-ZORB.PDT_2104.PV</th>\n",
       "      <th>S-ZORB.SIS_PDT_2103B.PV</th>\n",
       "      <th>S-ZORB.TC_2101.PV</th>\n",
       "      <th>...</th>\n",
       "      <th>S-ZORB.CAL_1.CANGLIANG.PV</th>\n",
       "      <th>S-ZORB.FT_1006.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_5204.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_1006.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.FT_5204.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.FT_1503.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_1503.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.FT_1504.DACA.PV</th>\n",
       "      <th>S-ZORB.FT_1504.TOTALIZERA.PV</th>\n",
       "      <th>S-ZORB.PC_1001A.PV</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>0.261936</td>\n",
       "      <td>17.183467</td>\n",
       "      <td>2.417056</td>\n",
       "      <td>850.300855</td>\n",
       "      <td>424.968595</td>\n",
       "      <td>424.522167</td>\n",
       "      <td>2.315898</td>\n",
       "      <td>61.701366</td>\n",
       "      <td>1250.6929</td>\n",
       "      <td>245.333915</td>\n",
       "      <td>...</td>\n",
       "      <td>2.894837</td>\n",
       "      <td>10013.864775</td>\n",
       "      <td>147.165737</td>\n",
       "      <td>87939278.25</td>\n",
       "      <td>2205865.275</td>\n",
       "      <td>1943.691157</td>\n",
       "      <td>2149491.8</td>\n",
       "      <td>2501.854175</td>\n",
       "      <td>2154163.85</td>\n",
       "      <td>-113.375918</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 354 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    S-ZORB.CAL_H2.PV  S-ZORB.PDI_2102.PV  S-ZORB.PT_2801.PV  \\\n",
       "40          0.261936           17.183467           2.417056   \n",
       "\n",
       "    S-ZORB.FC_2801.PV  S-ZORB.TE_2103.PV  S-ZORB.TE_2005.PV  \\\n",
       "40         850.300855         424.968595         424.522167   \n",
       "\n",
       "    S-ZORB.PT_2101.PV  S-ZORB.PDT_2104.PV  S-ZORB.SIS_PDT_2103B.PV  \\\n",
       "40           2.315898           61.701366                1250.6929   \n",
       "\n",
       "    S-ZORB.TC_2101.PV  ...  S-ZORB.CAL_1.CANGLIANG.PV  S-ZORB.FT_1006.DACA.PV  \\\n",
       "40         245.333915  ...                   2.894837            10013.864775   \n",
       "\n",
       "    S-ZORB.FT_5204.DACA.PV  S-ZORB.FT_1006.TOTALIZERA.PV  \\\n",
       "40              147.165737                   87939278.25   \n",
       "\n",
       "    S-ZORB.FT_5204.TOTALIZERA.PV  S-ZORB.FT_1503.DACA.PV  \\\n",
       "40                   2205865.275             1943.691157   \n",
       "\n",
       "    S-ZORB.FT_1503.TOTALIZERA.PV  S-ZORB.FT_1504.DACA.PV  \\\n",
       "40                     2149491.8             2501.854175   \n",
       "\n",
       "    S-ZORB.FT_1504.TOTALIZERA.PV  S-ZORB.PC_1001A.PV  \n",
       "40                    2154163.85         -113.375918  \n",
       "\n",
       "[1 rows x 354 columns]"
      ]
     },
     "execution_count": 87,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_313.tail(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_285.to_excel(\"285样本处理完毕数据.xlsx\", index=False)\n",
    "data_313.to_excel(\"313样本处理完毕数据.xlsx\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
